var sqlMap = {
    user: {
        add: 'insert into user (username, email, password, type) values (?,?,?,?)',
        select: 'select * from user',
        addlog: 'insert into loglogin (username,email,type,logtime,logcity) values(?,?,?,?,?)'
    },
    course: {
        select: 'select * from courses',
        add: 'insert into courses (course_name,email,img_url,course_description) values (?,?,?,?)',
    },
    personal_info: {
        //name ,sex , birthday , identity , school ,education, region, work_experience
        update: 'update personal_info set name = ?,sex = ?, birthday = ?, identity = ?, school = ?,education = ?, region = ?, work_experience = ?'
    }
}

module.exports = sqlMap;